Michelle: The Avg concentration values for a given WWTP don’t correlate well with the PMMoV normalized values for the same WWTP - where I saw decent correlation values when I ran this. Something seems off with the avg concentration values?
Jules: It looks like it has something to do with the “oldest” data that was just added to the system. Something is definitely different there - the easiest way to troubleshoot that would probably be if I could look at the dataset Michelle was using?
## [1] "Date" "AA_NorovirusAvgConc" "AA_NVnormalizedPMMoV"
## [4] "FL_NorovirusAvgConc" "FL_NVnormalizedPMMoV" "JS_NorovirusAvgConc"
## [7] "JS_NVnormalizedPMMoV" "TM_NorovirusAvgConc" "TM_NVnormalizedPMMoV"
## [10] "YC_NorovirusAvgConc" "YC_NVnormalizedPMMoV" "MI_Noro"
## [13] "MI_SF" "DET_Noro" "DET_SF"
## [16] "DET_GE" "MI_GE"
## [1] "Correlation Scatter Plots, Lag = 7"
## [1] "Correlation Scatter Plots, Lag = 14"
## [1] "Correlation Scatter Plots, Lag = 21"
## [1] "Correlation Scatter Plots, Lag = 7"
## [1] "Correlation Scatter Plots, Lag = 14"
## [1] "Correlation Scatter Plots, Lag = 21"
Michelle: For the cross correlations the labels said that the search data lagged compared to WW data. The results in slide 9 show values correlate best when NV search term is 7 to 21 days (14 for YC) earlier than wastewater values for Detroit (-21 to -7 lag). Am I understanding this wrong? If we look at the graph in slide 8, NV seems to be coming up later than the WW values for YC. | Values correlate best when Detroit metro SF search term is the same day as WW values (except TM), more variation seen for MI SF search timing.
Jules: The data here has the Search data lagged relative to the WW data (so, the WW dates are held constant, and the “lag” is for the search data, and therefore a “-7 day lag” means that the data for WW was held true [ex. 11/21/2022] and assigned the search data from seven days later [11/28/2022]) – Updated 11/30/2022: The WW data is lagged relative to the Search data (so, the Search dates are held constant, and the “lag” is for the WW data, and therefore a “-7 day lag” means that the data for Search was held true [ex. 11/21/2022] and assigned the WW data from seven days later [11/28/2022])